package org.bonorsoft.modules.hospital.mapper;

import org.apache.ibatis.annotations.Select;
import org.bonorsoft.modules.hospital.entity.TotalEntity;

import java.util.List;

/**
 * @Description: 统计
 * @Author: WilliamYe
 * @Date:   2020-10-14
 * @Version: V1.0
 */
public interface TotalMapper {

    @Select("SELECT dbo.getmzl(GETDATE())")
    Integer getTodayOutpatient();

    @Select("select * from dbo.get_record_data(#{year})")
    List<TotalEntity> getRecordData(Integer year);

    @Select("select * from dbo.get_common_data(#{year})")
    List<TotalEntity> getCommonData(Integer year);

    @Select("select * from dbo.get_outer_court(#{year},#{type})")
    List<TotalEntity> getSuperiorData(int year, int type);
}
